My Stuff
Community Articles: What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now and spark the next big discussion!
-
Re: Is it possible to populate Class based on Items lookup in Sales Transactions saved search
Hi Prtk, It will give you null values if the Class field is blank on the Item Record. Do you want to have a text populate the column instead of a blank? You can do this by adding a Formula (Text) fie…1 -
Re: A/R account doesn't Auto Populate
Hi @Biomerics_Admin, Thank you for being with us today and for posting your question here! Kindly allow our gurus/members some time to check this one for you and we will get back to you with our find…1 -
Re: Convert String to date in saved search
You're welcome, Bee! Glad I could help! ?1 -
Re: Convert String to date in saved search
The error might be happening because there are some lines in the search that are returning "invalid" when trying to convert the string to a date. For example, the lot number is WSA-20231025…1 -
Re: Convert String to date in saved search
Hi there Bee @User_IE7NG, I've tested this one out, and I've come up with these Formula: If using Formula (Text): (SUBSTR(REGEXP_SUBSTR({inventorynumber},'[^-]+$'),5,2)) || '…1
